package com.hos.db.create.consult;

/**
 * 咨询
 * Created by guom on 2018/10/15.
 */
public class ConsultTable {
    public static String tableName = "consults";
    public static String tableConsultId = "consult_id";//咨询id
    public static String tableConsultTitle = "consult_title";//咨询标题
    public static String tableConsultContent = "consult_content";// 咨询内容
    public static String tableConsultImages = "consult_images";// 咨询图片
    public static String tablePatId = "consult_pat_id";//  医生id
    public static String tableDocId = "consult_doc_id";//  患者id
    public static String tableConsulState = "consult_state";//   0 新的咨询 1：已回答 2：已结束
    public static String tableConsultFinishTime = "consult_finish_time";// 结束时间
    public static String tableConsultReplyTime = "consult_reply_time";// 最后回复时间
    public static String tableConsultCreateTime = "consult_create_time";// 消息创建时间
    public static String tableConsultUpdateTime = "consult_update_time";// 消息创建时间

    //
    public static String careteTable = "create table  "
            + tableName + " ( "
            + tableConsultId + "  varchar(200) primary key, "//主键
            + tableConsultTitle + " varchar(200), "
            + tableConsultContent + " longText, "
            + tableConsultImages + " longText,"
            + tablePatId + " varchar(100), "
            + tableDocId + " varchar(100), "
            + tableConsulState + " int, "
            + tableConsultReplyTime + " datetime, "
            + tableConsultFinishTime + " datetime, "
            + tableConsultCreateTime + " datetime, "
            + tableConsultUpdateTime + " datetime "
            + "); ";

}
